@echo off
set DB_SERVER=havi-server

set DB_USER=lsos
set DB_PWD=lsos
set DB_NAME=lsos_prod

echo start... > log.txt
echo ***************************************>> log.txt
echo execute SP_SUN_QUERY_DSI.sql start >>log.txt
if not exist "D:\SRoot\Design\DB\Stored Procedure\sunInterface2\SP_FA_CALC_STD_COST.sql"    echo "file not found" >> log.txt
mysql --host=%DB_SERVER% --user=%DB_USER% --password=%DB_PWD% --database=%DB_NAME% < "D:\SRoot\Design\DB\Stored Procedure\sunInterface2\SP_FA_CALC_STD_COST.sql" 2>&1  1>>log.txt 
echo execute SP_SUN_QUERY_DSI.sql end >>log.txt

echo ***************************************>> log.txt
echo execute SP_SUN_QUERY_DSI.sql start >>log.txt
if   not exist "D:\SVNRoot\Design\DB\Stored Procedure\sunInterface2\SP_FA_CALC_STD_COST.sql"  echo "file not found" >> log.txt
mysql --host=%DB_SERVER% --user=%DB_USER% --password=%DB_PWD% --database=%DB_NAME% < "D:\SVNRoot\Design\DB\Stored Procedure\sunInterface2\SP_FA_CALC_STD_COST.sql" >>log.txt 2>>&1 

echo execute SP_SUN_QUERY_DSI.sql end >>log.txt
echo ***************************************>> log.txt

